| |
135 Search Results Found |
| 1 |
Forum: Marketplace «»
Posted on: Fri, 12 June 2020 12:15 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DESCRIBE command
The DESCRIBE command is another way to get information about a Data Pump job.
The syntaxes of this command are:
McDP [<logon>] { -desc | --describe } [<schema>.]<dp job> [[-opt] <display/trace option>]
…
|
| 2 |
Forum: Forms «»
Posted on: Sat, 13 August 2022 03:29 «»
By: sasipalarivattom
Re: Files generated on server with sufix
…report in URL
like http://WIN-SERV:9002/reports/rwservlet?server=rep_server1&report=test.rdf&destype=file&desformat=html&userid=scott/ti ger@orcl&desname=c:\rep1.html
is it also appending something to the output file…
|
| 3 |
Forum: Marketplace «»
Posted on: Tue, 20 March 2018 05:47 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
COPY tables and views (new in version 2018.03.20)
This new McDP command allows you to copy tables and views from a schema to another or the same one, possibly renaming them or not (see Data Pump engine restrictions at the bottom of the page).
When …
|
| 4 |
Forum: Server Utilities «»
Posted on: Fri, 08 December 2017 22:45 «»
By: Barbara Boehmer
Re: loading data from twitter with sqlldr
…need to have something in your data that can be used to either identify when a record begins or when a record ends. You have used
continueif last != ','
to tell it that the record is continued on the next line if the last character on the current …
|
| 5 |
Forum: Server Utilities «»
Posted on: Tue, 29 August 2017 10:59 «»
By: BlackSwan
Re: IMP-00010: not a valid export file, header failed verification
…>i think it was created by exp
You think wrongly.
exp does NOT have any DIRECTORY= parameter
[oracle@vbgeneric ~]$ exp help=yes
Export: Release 12.2.0.1.0 - Production on Tue Aug 29 11:57:27 2017
Copyright (c) 1982, 2017, Oracle and/or …
|
| 6 |
Forum: Server Utilities «»
Posted on: Fri, 30 December 2016 18:05 «»
By: Barbara Boehmer
Re: SQL Loader double quotes in clob data (3 threads from 2 sub-forums merged by bb)
…your control file, use:
infile * "str'AM'"
In your command line, where you specify data= ... your file path will be different from mine. I am using Windows, so I use \ instead of /. Also, if there are spaces or other unusual characters …
|
| 7 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:14 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
USER command
The last command of the first version of McDP is not a real Data Pump command as it does not use its engine but it is a useful one for a requirement that is often asked to DBA: get the DDL to recreate one or several accounts, possibly …
|
| 8 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:12 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
DISPLAY job command
After the LIST command the first thing that comes in mind is "can I have more information about this specific job?" and the answer is "Yes, using the DISPLAY command on this job".
Its syntax is:
McDP [<…
|
| 9 |
Forum: Marketplace «»
Posted on: Mon, 22 August 2016 10:11 «»
By: Michel Cadot
Re: McDP: like expdp/impdp Data Pump programs and much more
…
LIST command
I will start with LIST command which is the default action if you specify none.
If you have a privileged account, McDP will list all Data Pump jobs otherwise you will see only yours.
Syntax:
McDP [<logon>] [{ -l | --list }] [&…
|
| 10 |
Forum: JDeveloper, Java & XML «»
Posted on: Sat, 02 April 2016 15:16 «»
By: Barbara Boehmer
Re: XML structure into regular table
…is a slight variation. I am not sure which would be more efficient.
SCOTT@orcl> insert all
2 when rn = 1 then
3 into notes (userid, to_col, from_col, contents)
4 values (userid, to_col, from_col, contents)
5 when 1 = 1…
|
| 11 |
Forum: Replication «»
Posted on: Sat, 08 August 2015 21:42 «»
By: Dharmat@gmail.com
OGG-01921 Oracle GoldenGate Delivery for Oracle, rep1.prm: Missing GETBEFORECOLS with conflict det
…All,
I am trying CDR(conflict data resolution) but I am getting the following error
2015-08-08 18:09:44 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 started.
2015-08-08 18:09:44 ERROR OGG-01921 Oracle …
|
| 12 |
Forum: Reports & Discoverer «»
Posted on: Mon, 24 March 2014 05:27 «»
By: pre_ora
Reports location or path
…t=D:\dummy_folder\reports-files\test.rdf&userid=scott/tiger@something &desformat=html&destype=cache
but Our senior recommends that report should run using only name of report...i.e;
http://machine:port/reports/rwservlet?server=sernm&…
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Tue, 04 February 2014 04:28 «»
By: John Watson
Re: Error in PL/SQL Procedure using UTL_HTTP
…Well, I've tried your code and it runs for me without error. Of course, I do not know if you are getting the SMSs. See below, I'm using http, not https, because I don't have your digital certificate:orclz>
orclz> conn / as sysdba
Connected.
orclz…
|
| 14 |
Forum: Reports & Discoverer «»
Posted on: Fri, 25 October 2013 18:24 «»
By: suj_it
Re: How to Hide Username and Password in WEB.SHOW_DOCUMENT
…=RptSvr_app01_dvlp&destype=cache&desformat=pdf&report=audit_counts.rep&userid=scott/tiger@rwdvlp&end_date=25-OCT-2013&start_date=01-OCT-2013&p_auditor=ALL&p_hub=1099
I have not tried the cookie method suggested by dllinf…
|
| 15 |
Forum: JDeveloper, Java & XML «»
Posted on: Thu, 19 September 2013 14:04 «»
By: Barbara Boehmer
Re: XML issue
…looks like you figured it out while I was posting. I corrected a couple of mis-matched column names for the abc table, then put it all together below.
SCOTT@orcl12c> -- test data:
SCOTT@orcl12c> COLUMN pat_mrn FORMAT A7
SCOTT@orcl12c>…
|
| 16 |
Forum: Forms «»
Posted on: Tue, 15 January 2013 08:37 «»
By: RAM_PIPL
How to run Direct printing in forms 10g
…am using Oracle 10g forms and report. I want to run report directly in printer.without generating pdf. for this i have used this code
WEB.SHOW_DOCUMENT('ram:8889/reports/rwservlet?report=D:\working\test.rep&userid=epps/scott@tigerprod&destype=…
|
| 17 |
Forum: Reports & Discoverer «»
Posted on: Tue, 04 September 2012 03:18 «»
By: new_oracle2011
Re: how to call report automatically
…ep_pda_server_frhome1+report=AUTO_REPORT.rdf+userid=scott/tiger@db.world+desformat= pdf+DESTYPE=mail+DESNAME="xyz@abc.com"=CC="xyz@abc.com"+BCC="xyz@abc.com"+REPLYTO="xyz@abc.com"+FROM="xyz@…
|
| 18 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 13 August 2012 05:10 «»
By: Littlefoot
Re: incrementally increasing userid value via looping
…then, here you are.
SQL> create table reg_user as
2 select ename from emp;
Table created.
SQL> alter table reg_user add userid number;
Table altered.
SQL> declare
2 cursor cur_e is
3 select ename from reg_user…
|
| 19 |
Forum: Server Utilities «»
Posted on: Wed, 25 July 2012 18:27 «»
By: alan.kendall@nfl.com
Re: Running exp and imp command on 11.2.0.1.0 Production version
…11g imports from prior Oracle Versions I have had some corruption issues so I have had to
truncate or drop partially imported tables and import the tables one at a time after doing individual
table exports.
SCOTT > @…
|
| 20 |
Forum: Server Utilities «»
Posted on: Mon, 16 July 2012 19:45 «»
By: alan.kendall@nfl.com
Re: Export Multiple tables only
…have used the following sql to generate exports with multiple tables in each export dump file. The backslash tells the Unix OS that the open parenthesis and the close parenthesis are not to parsed by the Unix OS. Also the backslash is added to each line …
|
| 21 |
Forum: Backup & Recovery «»
Posted on: Wed, 11 July 2012 01:30 «»
By: Michel Cadot
Re: Taking a dump of huge table
…classic "exp":
C:\>exp help=y
Export: Release 10.2.0.4.0 - Production on Mer. Juil. 11 08:27:45 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Export prompt you for parameters by entering the EXP
…
|
| 22 |
Forum: Reports & Discoverer «»
Posted on: Sun, 22 April 2012 17:30 «»
By: eng_amrelhanafy
Problem in printing pdf report
…print it , It prints normally .
The code I use to call report is
web.show_document('//localhost:8889/reports/rwservlet?server=rserver&report=rep1.rdf&destype=cache&desformat=pdf&userid=scott/tiger@orcl');
Could anybody help…
|
| 23 |
Forum: Reports & Discoverer «»
Posted on: Fri, 10 February 2012 13:52 «»
By: Littlefoot
Re: Is there a way to automate Oracle Reports?
…a DOS batch script (for example, "run_report.bat") which you'd schedule in Task Manager. It would contain two lines:
rwrun report=monthly.rdf userid=scott/tiger@ora10 desformat=pdf DESTYPE=file DESNAME=c:\my_reports\monthly.pdf
mail…
|
| 24 |
Forum: Forms «»
Posted on: Sun, 18 December 2011 05:37 «»
By: aallan
Sql Loader Problem
…D:\oracle\product\10.2.0\db_1\BIN\sqlldr.exe USERID=Scott/Tiger@ORCL Control= '|| 'C:\FORMAT.Ctl'); if the db on the server
--Host('C:\Windows\System32\Cmd.exe /C D:\oracle\product\10.2.0\db_1\BIN\sqlldr.exe USERID=Scott/Tiger@ORCL Control= '|| 'C:\…
|
| 25 |
Forum: Server Utilities «»
Posted on: Thu, 20 October 2011 09:16 «»
By: BlackSwan
Re: importing full database with different database name and sid
…all else fails Read The Fine Help info!
bcm@bcm-laptop:~$ impdp help=yes
Import: Release 11.2.0.1.0 - Production on Thu Oct 20 07:15:24 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
The Data Pump Import…
|
| 26 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Tue, 31 May 2011 05:40 «»
By: jamal_s
Re: Generating Scheduler for Some Procedures
…and password here and connectivity string
userid=scott/tiger@test
colorScheme=teal
splashScreen=no
lookandfeel=oracle
workingDirectory=c:\test
then save your formsweb.cfg
now you can call this form from your browser by
giveing
'your Ip':'…
|
| 27 |
Forum: Server Utilities «»
Posted on: Wed, 08 December 2010 14:23 «»
By: Littlefoot
Re: Calling SQL*Loader utility with alias instead of password
…is OK - loads data):C:\TEMP>sqlldr userid=scott control=test.ctl log=test.log
Password:
SQL*Loader: Release 10.2.0.1.0 - Production on Sri Pro 8 21:19:56 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Commit point reached - …
|
| 28 |
Forum: Server Utilities «»
Posted on: Fri, 15 October 2010 19:38 «»
By: Barbara Boehmer
Re: SQL LOADER
…ARCHAR2(15) CONSTRAINT PK_FREG PRIMARY KEY,
FIRMAS_NOS VARCHAR2(25) CONSTRAINT NN_FNOS NOT NULL,
ID_PRODUCT VARCHAR(15)
)
/
host sqlldr userid=scott/tiger control=firmas.ctl log=test.log
select * from firmas
/
spool off
ed test.txt
ed test.log…
|
| 29 |
Forum: Forms «»
Posted on: Mon, 28 June 2010 06:17 «»
By: ranamirfan
To Hide UserName & Password in Reports11g - Urgent
…estype=cache desformat=html server=repserver userid=scott/tiger@mydb %P
;
Example 6: take all URL arguments, and also generate a HTML parameter form
runp: %* %P
;
Example 7: Run an Express Report. Replace <MYHOST> with the name of the …
|
| 30 |
Forum: Server Utilities «»
Posted on: Thu, 25 March 2010 08:47 «»
By: Michel Cadot
Re: How to export one table to few separated dump files?
…C:\>expdp help=y
Export: Release 10.2.0.4.0 - Production on Thursday, 25 March, 2010 14:45:55
Copyright (c) 2003, 2007, Oracle. All rights reserved.
The Data Pump export utility provides a mechanism for transferring data objects
between …
|
| 31 |
Forum: Server Utilities «»
Posted on: Mon, 04 January 2010 08:14 «»
By: Michel Cadot
Re: import from split
…No.
Here's the syntax of import:
C:\>imp help=y
Import: Release 10.2.0.4.0 - Production on Lun. Janv. 4 13:16:16 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the …
|
| 32 |
Forum: Server Administration «»
Posted on: Sat, 26 December 2009 12:02 «»
By: Michel Cadot
Re: Moving subsets of data between servers
…you can use exp with the query clause on this id.
C:\>exp help=y
Export: Release 10.2.0.4.0 - Production on Sam. DÚc. 26 18:59:24 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Export prompt you for parameters by …
|
| 33 |
Forum: Precompilers, OCI & OCCI «»
Posted on: Thu, 24 September 2009 10:04 «»
By: hysat429
using object types in pro*c/c++
…
ott command : ott userid=scott/tiger code=C intype=inpfile outtype=ottouttype hfile=obj_background_job_array.h
the command generated the header file and an outtype file
obj_background_job_array.h :
#ifndef OBJ_BACKGROUND_JOB_ARRAY_ORACLE
# define…
|
| 34 |
Forum: Server Utilities «»
Posted on: Wed, 01 July 2009 09:47 «»
By: BlackSwan
Re: import issue
…
impdp help=yes
Import: Release 10.2.0.4.0 - Production on Wednesday, 01 July, 2009 7:46:15
Copyright (c) 2003, 2007, Oracle. All rights reserved.
The Data Pump Import utility provides a mechanism for transferring data objects
between Oracle…
|
| 35 |
Forum: Server Utilities «»
Posted on: Sun, 07 June 2009 08:15 «»
By: babuknb
Re: how to export statistics of table without table structure in oracle 9i
…
Addition;
C:\>imp help=y
Import: Release 10.2.0.4.0 - Production on Mon Jun 8 18:36:26 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Import prompt you for parameters by entering the IMP
command followed by …
|
| 36 |
Forum: Server Utilities «»
Posted on: Sun, 17 May 2009 10:47 «»
By: shrinika
Re: Impdp with multiple dump file directories
…Mahesh, There was a mistake in my first post in this thread. My expdp parfile content was wrong...
But anyhow, i did not have any issues on expdp. I have concern only on impdp.
I am testing this in my local machine and i am using Windows XP.
Here is…
|
| 37 |
Forum: Server Utilities «»
Posted on: Mon, 20 April 2009 18:09 «»
By: shrinika
SQLLoader(DIRECT=FLASE, PARALLEL=TRUE)
…
C:\Loader>sqlldr control=case1.ctl userid=scott/tiger@orcl file=case1.ctl log=ca
se1.log parallel=TRUE direct=FALSE
SQL*Loader: Release 10.1.0.2.0 - Production on Mon Apr 20 19:03:22 2009
Copyright (c) 1982, 2004, Oracle. All rights …
|
| 38 |
Forum: Server Utilities «»
Posted on: Mon, 13 April 2009 09:37 «»
By: Michel Cadot
Re: Solving Convertible Data
…
This is NOT what csscan says. It says "convertible".
C:\>exp help=y
Export: Release 10.2.0.4.0 - Production on Lun. Avr. 13 16:35:38 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
You can let Export prompt …
|
| 39 |
Forum: Forms «»
Posted on: Mon, 30 March 2009 04:51 «»
By: shahzaib_4vip@hotmail.com
how to run form 10g
…question is
how to run form in developer suit i was using developer 6I now i want to run my module to developer suit 10g first i install developer suit 10g then database 10g and make a simple module of emp table
now when i run its give me error …
|
| 40 |
Forum: Security «»
Posted on: Tue, 24 March 2009 10:37 «»
By: kafaween
Re: user always gets lock
…sweb.cfg in Oracle Application Server , i.e. userid=scott/tiger@db) , then put two text boxes in your form (username , password) insert the values of the user in your specified table , if the form success then logout from the scott user and logon using …
|
Blog
Search
Help
Members
Register
Login
Home